package com.nbjtjc.safe.mapper.edu;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.nbjtjc.safe.model.edu.EduReassignment;
import com.nbjtjc.util.MyMapper;
@Mapper
public interface EduReassignmentMapper extends MyMapper<EduReassignment> {

	List<EduReassignment> search(@Param("er") EduReassignment eduReassignment);
	
	List<EduReassignment> searchDetail(@Param("er") EduReassignment eduReassignment);

	
    @Select("SELECT DISTINCT DATE_FORMAT(training_date,'%Y') AS 'year' FROM edu_reassignment where company_id = #{companyId} and training_date is not null")
    List<String> findYear(@Param("companyId")Integer companyId);

//	List<EduReassignment> searchHis(@Param("er") EduReassignment eduReassignmentSample);
}